UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pVd1y/aKwMOyxfpu3tEzOCB5b2E0QWi9bRIe4RE5Fco='
WHERE
key_id = 'efebf54fd7d8527a30091e9dd640b937c5af35c7295a1e6ded9248790dcb1a16'
AND (
token = 'pVd1y/aKwMOyxfpu3tEzOCB5b2E0QWi9bRIe4RE5Fco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)