UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BC0dRy8pRAtQttEKtcXeKNAVUHkW709jr71qLZWV2pY='
WHERE
key_id = '3540d9621aac4d87d78acda45023d7a9b0e040ee07566d118064f4deeb26f31b'
AND (
token = 'BC0dRy8pRAtQttEKtcXeKNAVUHkW709jr71qLZWV2pY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)