UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dlE6cbIojL+ZW9K6BTF6Hqf9eSn0zGKBNUGtGR6o29s='
WHERE
key_id = '49d115cc17a305fe5ae652206cd4fc70f7ab1468f439f8180a0fbf89b34a7603'
AND (
token = 'dlE6cbIojL+ZW9K6BTF6Hqf9eSn0zGKBNUGtGR6o29s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)