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