UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NWgnpdmh6U2Ss5Bv7wtvcWS2FM3T2yWGzyxaKUYeJ08='
WHERE
key_id = 'c0344b4745871d1612b4d258d208af5fbb41d6811e49404f52e99f55b84faf86'
AND (
token = 'NWgnpdmh6U2Ss5Bv7wtvcWS2FM3T2yWGzyxaKUYeJ08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)