UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gUaihOcU6fjqz9k0zTg8Kwy0RpnCqmEJaiSwe0oCZyQ='
WHERE
key_id = '993f50ee6d374a7819921690954092047e81654b059ec7e575e7c604eb1c904b'
AND (
token = 'gUaihOcU6fjqz9k0zTg8Kwy0RpnCqmEJaiSwe0oCZyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)