UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i6yPac8uodYrXFpseRm6Pyvx12IhfuT2FtYu+mGTaBI='
WHERE
key_id = '9df484d3399c019f351f222dcb508fb74d8c5e9b62587f9d7a8d7ac826c49f6d'
AND (
token = 'i6yPac8uodYrXFpseRm6Pyvx12IhfuT2FtYu+mGTaBI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)