UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6/zzfTaewW90YfcDfPvmwIrhRRzrvsBfB48Ii2sX81M='
WHERE
key_id = '419dd924384e5ca1e1790511ba5f01796c514a5507c980b9e3334dd7f5cad22a'
AND (
token = '6/zzfTaewW90YfcDfPvmwIrhRRzrvsBfB48Ii2sX81M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)