UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YV6BDroXM5W5cqrqLdAMJ6to9yfZXrQXcPr8M7H04nM='
WHERE
key_id = 'bbfea1ce5bf0fb3f79603ab123c40b47c9661111b96da0f11bee2107f13b542a'
AND (
token = 'YV6BDroXM5W5cqrqLdAMJ6to9yfZXrQXcPr8M7H04nM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)