UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lLYn+eOSVvVehD5j23Ukw60sqo89UiEnk2Qn5Gd6lYA='
WHERE
key_id = 'b9416df8802701ef8b290d13fde84c7f4d79a85b60fab3a70833859886032eae'
AND (
token = 'lLYn+eOSVvVehD5j23Ukw60sqo89UiEnk2Qn5Gd6lYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)