UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6kIz23Crzq2mZi72jQqm1L31Jb9dvJRFITRALVgUiL4='
WHERE
key_id = '8a8c857a6b005907e3d0f9597395ca123668fcf083180bc70989b2bff8deead3'
AND (
token = '6kIz23Crzq2mZi72jQqm1L31Jb9dvJRFITRALVgUiL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)