UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nlYzdYLmrab8LhRrbaAYZlFgqy+iXw5fK7JWCAMSFeU='
WHERE
key_id = 'e46c4ff535e5579020dc86ba7b9d860f9f12296e58ce3431ae35d6af97c5305d'
AND (
token = 'nlYzdYLmrab8LhRrbaAYZlFgqy+iXw5fK7JWCAMSFeU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)