UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nHmSHtBn9eGbGPJ+eS723gZBX1ATC8EL+O5Y8Q/XXnQ='
WHERE
key_id = '588f24ee0d4028b60e291760f4adb0f6640c28d492d4ab12b447f5a67c8fa724'
AND (
token = 'nHmSHtBn9eGbGPJ+eS723gZBX1ATC8EL+O5Y8Q/XXnQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)