UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z7R32VPER1gWK9kO0hPamoY3FHmOCUOIZah1umPXmrA='
WHERE
key_id = '98986afe9672939668954efc4bac37e6abe0dd9f02fa7ab42a2dc0c76a7a29de'
AND (
token = 'Z7R32VPER1gWK9kO0hPamoY3FHmOCUOIZah1umPXmrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)