UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8MnDkFgeLm5E2rygTXIFo/XjvwBBoqYcglsxj8Oo4lw='
WHERE
key_id = 'a7141d3f5e5332e00533d7a4512c575ceb7cbb6cff341e30897bc2c405dd45c2'
AND (
token = '8MnDkFgeLm5E2rygTXIFo/XjvwBBoqYcglsxj8Oo4lw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)