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