UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tKfq7E/xOhfAPX4YGbp6thXYYD1qpm+L48pws630Nms='
WHERE
key_id = 'bb48f2c7c06b3061cedc7a7f211c8ec5f669ed53d1c998f1a1f7597cb61a92c1'
AND (
token = 'tKfq7E/xOhfAPX4YGbp6thXYYD1qpm+L48pws630Nms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)