UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GXkRbHdmytvU1VukBCRTR7du5ao/PAxEg5XkGwc6udM='
WHERE
key_id = 'e8dabd26512b204bb8a4c577986b975a5ca539697058d8ab7809b15e2545aa8d'
AND (
token = 'GXkRbHdmytvU1VukBCRTR7du5ao/PAxEg5XkGwc6udM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)