UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jGbVC/8Oa6Xp1qLw51Iyt/O9KG9spxqLYtN8hQW1f/E='
WHERE
key_id = '47ee042cb812b5f2032dd0f15580cc9f57d6d67a44ae03ac12344f9e325b7648'
AND (
token = 'jGbVC/8Oa6Xp1qLw51Iyt/O9KG9spxqLYtN8hQW1f/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)