UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wX2+pUK8ghkNyxwlaiwqOYEzNA09jyCVOX3zwyK77YM='
WHERE
key_id = 'f56b31adf1afa6b70641ce20a64647ddf37cf98c1e728e1587605ef085853a23'
AND (
token = 'wX2+pUK8ghkNyxwlaiwqOYEzNA09jyCVOX3zwyK77YM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)