UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bMzX76OiwbEbBKzd0/ez6JPDrGo34GfJP3lsc08XoF0='
WHERE
key_id = '47c403728a6d957219939760b5e56a3e4e13a8e061312087fd37f920f3942b25'
AND (
token = 'bMzX76OiwbEbBKzd0/ez6JPDrGo34GfJP3lsc08XoF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)