UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '96wj0rJNY2ypBVPBiGkz8AfSUsBb9dg5/wXYaWdKmVQ='
WHERE
key_id = '81367fe0f89997db336a2549081bf719072f49256879b76f0f8611379ee8caed'
AND (
token = '96wj0rJNY2ypBVPBiGkz8AfSUsBb9dg5/wXYaWdKmVQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)