UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hlHwJdBEZpxTBvdlOLcwrxMpj4e4P9xWxZWFAJzwxtI='
WHERE
key_id = 'fd38a900f47268a6a37fc96a3930b77b179a9e3305cf024416880f680eee3020'
AND (
token = 'hlHwJdBEZpxTBvdlOLcwrxMpj4e4P9xWxZWFAJzwxtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)