UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ljUXJZBCagXjloXC2Ai78jd2Z7X8er/ymEM9ZCXwiU='
WHERE
key_id = '7ef0c520ed8c4a701e7a45ea749339c458532c68cf8887c77e65013e1247a8ca'
AND (
token = '1ljUXJZBCagXjloXC2Ai78jd2Z7X8er/ymEM9ZCXwiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)