UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Ppxvk/s1/uNPF3rnT+s5t36fnYG45ERtnVPsJi/qNU='
WHERE
key_id = '39f1107ae63921b8f9748b282b51744bbc2811cb6363403b2eed20e90897a400'
AND (
token = '8Ppxvk/s1/uNPF3rnT+s5t36fnYG45ERtnVPsJi/qNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)