UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hRB5lzL6S0kKeBXb1hVu/zzn4cSETpRkn9c+v8LzI9Q='
WHERE
key_id = 'c70b9fbd1dbd441415f68fea7d5acd70df71238bb0f56ae5774ff4d5d5973a39'
AND (
token = 'hRB5lzL6S0kKeBXb1hVu/zzn4cSETpRkn9c+v8LzI9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)