UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/GACVkYr9ojJPqdoHw06v3Bq3vXwpFDpgonrPgPTeUY='
WHERE
key_id = '6e69fe6f75d9dd7cd8367c68c8b5a25786947570ee4006ac44192da656ffa417'
AND (
token = '/GACVkYr9ojJPqdoHw06v3Bq3vXwpFDpgonrPgPTeUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)