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