UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j7i3zNYAiyNfuBW9PjBJqJe4LaoUt3gvBTr70KWlppk='
WHERE
key_id = 'be6220be2895d2a7187fa9ede31d104d87dab0ea47f4fbe2355cacd80d6b9502'
AND (
token = 'j7i3zNYAiyNfuBW9PjBJqJe4LaoUt3gvBTr70KWlppk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)