UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e3NAYEW643u6TtL8k/feSbEOCw8FOUGmy8dnxxDPJ9M='
WHERE
key_id = '4abffc1986dc764f493cffe7a64e8d33f8ee1ca5920e36732ddaf870703f9adc'
AND (
token = 'e3NAYEW643u6TtL8k/feSbEOCw8FOUGmy8dnxxDPJ9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)