UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ng6aqB/IxRteJcRXD0xzmOE5Ez/A5FP5zFDCXmBW+90='
WHERE
key_id = '77e20d45db60d166ae64585b27f4a7da0f9d30070efd4d33eb83794099874196'
AND (
token = 'ng6aqB/IxRteJcRXD0xzmOE5Ez/A5FP5zFDCXmBW+90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)