UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u8gJlfyCuUGZ8GPc1FR2AGnjn2w+egyBL/l4AuUBU1w='
WHERE
key_id = 'abee54df02a45485fb3cb7dc7ce7e4042746a32c480fbfcad5b716e2af575fee'
AND (
token = 'u8gJlfyCuUGZ8GPc1FR2AGnjn2w+egyBL/l4AuUBU1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)