UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zkJt+uamrXfwNipGDFcHI2sEORxvmMEeoTswhyf9Yhg='
WHERE
key_id = '4bf0335c9a2a220f14e1fa383b40e1311b89cdfb250743642007f80184ed1cfc'
AND (
token = 'zkJt+uamrXfwNipGDFcHI2sEORxvmMEeoTswhyf9Yhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)