UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2N/mnEUgALS90M7ls3CHHCWwxH0uksiU/tX5qt90zLg='
WHERE
key_id = '48678528e0c11f90876ddbb8900d94e6863470282dce9cb79def5a31807f811a'
AND (
token = '2N/mnEUgALS90M7ls3CHHCWwxH0uksiU/tX5qt90zLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)