UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WXxd6HJ311q5X+N+7SLd0Kmifcpp01S3eeFsjIxBv4w='
WHERE
key_id = 'e4e2c32ebd60a4e155011bec7774fd9b0fc8c562f37b4ef94c27f965f3b630ad'
AND (
token = 'WXxd6HJ311q5X+N+7SLd0Kmifcpp01S3eeFsjIxBv4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)