UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yZ34xRo3ZMkg+vQw5dg4cdK/ro/7PCF8P9+IF5NnWYo='
WHERE
key_id = 'a222ac4cbb60ec7cd97dd182714a651feed592df8c4d28fe1198240f3f68598f'
AND (
token = 'yZ34xRo3ZMkg+vQw5dg4cdK/ro/7PCF8P9+IF5NnWYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)