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