UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '46Uqla/W57fxZ5mpJIojjbkBkL5g38wQCISelvaPCu8='
WHERE
key_id = 'a7310ef09edd3dd99652aeb66891a9a3fca8bfef4ee5c1d2f16ad9542532ecce'
AND (
token = '46Uqla/W57fxZ5mpJIojjbkBkL5g38wQCISelvaPCu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)