UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XgcLtjd3SWRhGH1wHOPikdX/IR64j0fag/uoFB0Kk54='
WHERE
key_id = '162a9d564f738997b68db4b9119a3c2b120822a43585b11d7340e2adcb168a05'
AND (
token = 'XgcLtjd3SWRhGH1wHOPikdX/IR64j0fag/uoFB0Kk54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)